"Something like the following query, but including prices and descriptions: select ma. codmat, max (po. date) last_date from material ma left join purchaseorderitem pi on ma. codmat = pi. codmat left join purchaseorder po on pi. codord = po. codord Sorry, only registered users may post in this forum."